package com.jzo2o.customer.mapper;

import com.jzo2o.customer.model.dto.request.BankAccountUpsertReqDTO;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

@Mapper
public interface IBankAccountMapper {
    @Insert("insert into bank_account(id, type, name, bankName, province, city, district, branch, account, accountCertification) VALUES (#{id}, #{type}, #{name}, #{bankName}, #{province}, #{city}, #{district}, #{branch}, #{account}, #{accountCertification})")
    Integer install(BankAccountUpsertReqDTO bankAccountUpsertReqDTO);

    @Select("select * from bank_account where id = #{id}")
    BankAccountUpsertReqDTO selectByUserId(Long id);
}
